School Admin

prepare('select * from subjectss') ; $gts->execute() ; $subject = array() ; $sid = array() ; while($row = $gts->fetch(pdo::FETCH_ASSOC)) { $subject[] = $row['subjectname'] ; $sid[] = $row['subject_id'] ; } $lenght = count($subject) ; if(isset($_POST['submit'])) { $reg = $_POST['reg']; $subj = $_POST['subject']; //check if the student result has bee upload before $chk = $DBcon->prepare("select * from marks where((regno =:a and acyear =:b) and (term =:c and subject =:d))") ; $chk->bindparam(":a",$reg) ; $chk->bindparam(":b",$acyear) ; $chk->bindparam(":c",$schterm) ; $chk->bindparam(":d",$subj) ; $chk->execute() ; if($chk->rowcount() > 0) { $mes = "This subject has been uploaded before for this student, upload another one" ; } else { //get subject id $gtsid = $DBcon->prepare("select * from subjectss where subjectname =:d") ; $gtsid->bindparam(":d", $subj) ; $gtsid->execute() ; $rwd = $gtsid->fetch(pdo::FETCH_ASSOC) ; $subjid = $rwd['subject_id'] ; $test = $_POST['test'] ; $exam = $_POST['exam']; //$subjid = $sid[$x] ; $sql = $DBcon->prepare("insert into marks(acyear,term,klass,subject,subject_id,regno,level,test,exam,admin) values(:a,:b,:c,:d,:e,:f,:g,:h,:i,:j)"); $sql->bindparam(":a",$acyear) ; $sql->bindparam(":b",$schterm) ; $sql->bindparam(":c",$classid) ; $sql->bindparam(":d",$subj) ; $sql->bindparam(":e",$subjid) ; $sql->bindparam(":f",$reg) ; $sql->bindparam(":g",$lv) ; $sql->bindparam(":h",$test) ; $sql->bindparam(":i",$exam) ; $sql->bindparam(":j",$admin) ; if($sql->execute()) $mes = 'Published succesfully' ; } } ?> School Admin

Toping Up Individual Result

ADD SUBJECT CHANGE CLASS

Dashboard

Toping Up Individual Result